package net.trustie.dao;

import net.trustie.model.phpchina_Model;

import org.apache.ibatis.annotations.Insert;

public interface PHPChina_Dao {
	
	/*标准表中的字段*//*+ "insert into t_knowledge (`deal_title`,`author`,`content`,`tags`,`reply_num`,
	 * `view_num`,`vote_num`,`collection_num`,`abstract`,`type`,`crawled_time`,`url`,`created_time`,
	 * `category`,`source`,`history`,`author_url`,`last_time`,`url_md5`")*/
	
	/*标准表中的字段*/
	/*+ "insert into t_knowledge (`tags`,`abstract`,`type`,`crawled_time`, 
	 * `category`,`source`,`last_time`,`url_md5`")*/
	@Insert("insert into phpchina"
			+ "(`post_id`,`url`,`deal_title`,`content`,`view_num`,`reply_num`,`vote_num`,`vote_down`,"
			+ "`collection_num`,`created_time`,`shared_num`,`extractTime`,`author`,"
			+ "`author_url`,`pageMD5`,`history`)"
			
			
+ " values (#{postId},#{postUrl},#{postTitle},#{postContent},#{viewNum},#{replyNum},"
+ "#{voteUp},#{voteDown},#{favoritedNum},#{postTime},#{sharedNum},#{extractTime},#{postAuthor},"
+ "#{postAuthorUrl},#{pageMD5},#{history})")
			 
			/*1标准表中独有,设置为允许为空,INSERT需要补齐*/
			/*2与标准表对应字段*/
			/*3原社区中独有保留字段*/ 
			
			/*@Insert("insert into phpchina"
					+ "(`post_id`,`url`,`deal_title`,`content`,`view_num`,`reply_num`,`vote_num`,`vote_down`,"
					+ "`collection_num`,`created_time`,`shared_num`,`extractTime`,`author`,"
					+ "`author_url`,`pageMD5`,`history`,`1tags`,`1abstract`,`type`,"
					+ "`crawled_time`,`category`,`source`,`last_time`,`url_md5`)"		*/
			
			
	public int add(phpchina_Model phpChina_Model);
}
